Qid Examcode Question Qimpath opt1 opt2 opt3 opt4 opt5 opt6 opt7 opt8 opt9 opt10 opt11 opt12 opt13 opt14 opt15 impath1 impath2 impath3 impath4 impath5 impath6 impath7 impath8 impath9 impath10 impath11 impath12 impath13 impath14 impath15 answers uanswer CR Edit Delete
160 1Z0-063 One of your multitenant container databases (CDB) contains multiple pluggable databases (PDBs). 160-queadv.png The C##CONNECT role can be granted different roles and privileges in each PDB. C##ADMIN has the orcl123 password in all PDBs. The C##CONNECT role is granted to the C##ADMIN user in all PDBs CREATE SESSION is granted to the C##ADMIN user in all PDBs. The C##CONNECT role is a local role defined only in CDB$ROOT. 1, 3, 5 MC edit delete
159 1Z0-063 Examine this command: 159-queadv.png The command checks for blocks containing all zeros The command checks for blocks containing an invalid checksum. The command checks for blocks containing a corrupt block header The command checks for blocks that contain invalid column lengths The command backs up the database regardless of the state of the blocks The command backs up the database only if all blocks are valid. 1. 2. 3 MC edit delete
158 1Z0-063 Which three are true about RMAN duplexed backup sets or image copies? (Choose three.) A backup set may be duplexed with both copies written to disk. An image copy on sbt can be copied to disk. A backup set may be duplexed with both copies written to sbt. An image copy on disk can be copied to sbt. An image copy on disk can be copied to disk. A backup set may be duplexed so that one copy is written to sbt and the other to disk. 1, 3, 6 MC edit delete
157 1Z0-063 One of your databases supports a data warehousing workload and is in NOARCHIVELOG mode. You perform RMAN level 0 backup on Sundays and level 1 incremental backups on other days. One data file is corrupt and the current online redo log is missing due to media failure. Which four actions must you take for recovery? (Choose four.) Restore the missing data file Recover the database by using RECOVER DATABASE NOREDO; Recover the database by using RECOVER DATABASE Restore the control file Open the database by using the RESETLOGS option Recover the corrupt file by using RECOVER DATAFILE. Restore all data files. 2, 4, 5, 7 MC edit delete
156 1Z0-063 Which three statements are true about using RMAN without a recovery catalog? (Choose three.) No archive log deletion policies will be possible. The REPORT SCHEMA command will report only the current database schema CONTROL_FILE_RECORD_KEEP_TIME may need to be increased The RMAN backup retention can only be configured to use a redundancy based policy Database duplication will require a connection to the target CONTROL_FILE_RECORD_KEEP_TIME may need to be decreased 2, 3, 4 MC edit delete
155 1Z0-063 You want to duplicate one of your databases when connected to the target database and to the recovery catalog. Which three are true about this type of database duplication? (Choose three.) The duplication process can create backup sets or image copies The target database must be open. The duplication process pushes image copies to the auxiliary instance The duplication process can use existing backup sets or image copies The duplication process pushes backup sets to the auxiliary instance. The target database must be in mount state. 2, 5, 6 MC edit delete
154 1Z0-063 Your Oracle 12c multitenant container database (CDB) contains multiple pluggable databases (PDBs). 154-queadv.png C##ADMIN can create and select any table in HR_PDB. B_ADMIN can create and select any table only in HR_PDB A local role can be granted to c##role1 in a PDB C##ADMIN can create and select any table, and grant the C##ROLE1 role to users only in the root container Role c##role1 will always have the same privileges in each PDB. B_ADMIN can create and select any table in both the root container and HR_PDB. 1, 3, 5 MC edit delete
153 1Z0-063 Which two components are contained only in CDB$ROOT? (Choose two.) the unified audit trail database links between PDBs in the CDB PDB service names resource manager plans for each PDB in the CDB the default TEMP tablespace for the entire CDB 3, 5 MC edit delete
152 1Z0-063 Examine these actions: 152-queadv.png 2, 3, 6, 8 2, 4, 5, 7 l, 3, 5, 7, 9 1, 4, 5, 7, 9 1, 3, 5, 9 1, 3, 5, 8, 9 3 SC edit delete
151 1Z0-063 You plan to upgrade a production database running in NOARCHIVELOG mode that has no Fast Recovery Area configured. The upgrade must be reversable within as quickly as possible with the smallest overhead. Which three steps must you perform before you start the upgrade? (Choose three.) Configure a flashback retention target and the Fast Recovery Area. Configure the Fast Recovery Area. Configure the database in ARCHIVELOG mode. Create a normal restore point. Take a database backup. Create a guaranteed restore point. 1, 2, 3 MC edit delete
150 1Z0-063 Examine this query: 150-queadv.png Row movement must be enabled for CUSTOMERS Automatic Undo Management must be configured. FLASHBACK must be ON for the database Undo retention guarantee must be enabled. The database must be in ARCHIVELOG mode. Supplemental logging must be enabled. 2, 3 MC edit delete
149 1Z0-063 Which two are benefits of unified auditing in full mode? (Choose two.) The audit trail is in a single format. All audit data is written to both the traditional locations and to the unified location. The audit trail is read-only. Pre 12c audit data is written to the traditional locations and new 12c audit data is written to the unified location. The audit trail uses less space. 1, 3 MC edit delete
148 1Z0-063 You execute the RMAN commands: 148-queadv.png The default channel is allocated and the backup set is created in only one destination. Two channels are allocated and a copy of the backup set is taken in the location specified by CHANNEL 2. Two channels are allocated and backup pieces for the backup set are created in both the specified destinations. Two channels are allocated and two copies of the backup set are taken in parallel in both locations. 3 SC edit delete
147 1Z0-063 Examine this command: 147-queadv.png PDB2 will be open read-only. PDB2 will be in MOUNT state. A metadata description of PDB2 is stored in an XML file in ’/disk2/oracle/pdb2/’. A metadata description of PDB2 is stored in the system tablespace of PDB1. PDB2 will use shared UNDO 2,4 MC edit delete
146 1Z0-063 You execute the RMAN commands: 146-queadv.png One channel is allocated. Two channels are allocated. The backup set is created in parallel in two locations. The backup set is created in parallel only in one location. The backup set is created serially in only one location. 2, 3 MC edit delete
145 1Z0-063 You are required to migrate your 11.2.0.3 database to an Oracle 12c database. 145-queadv.png 1, 3, 5, 4, 2, and 7 1, 2, 4, 6, 5, 3 and 7 2, 4, 5, 3 and 7 1, 4, 5, 2 and 6 3, 5, 4, 2, and 7 1 SC edit delete
144 1Z0-063 Flashback Data Archive has been configured to retain data on all transactions that modify a table for a period of four years. 144-queadv.png An error is returned because the retention period cannot be reduced. Data from the first and third years is purged from the flashback archive FDA1. Flashback archive FDA1 retains all data and the retention period is increased by 2 years. Data older than two years, if any, is purged from the flashback archive FDA1. Data from the third year is purged from the flashback archive FDA1. 3 SC edit delete
143 1Z0-063 You want to create a guaranteed restore point for one of your databases by executing the command: 143-queadv.png The database must be in ARCHIVELOG mode. Flashback Database must be enabled. The Fast Recovery Area must be configured The database must be mounted. Undo retention guarantee must be enabled. The database must be opened. 1, 3 MC edit delete
142 1Z0-063 Which two are true about Oracle Secure Backup (OSB)? (Choose two.) It can be used to take proxy copies to tape. It can be used to take image copy backups to tape. It can be used to manage tape backup and restore operations for files. RMAN can backup up databases to OSB without requiring media manager channel parameters. It can be used to manage tape backup and restore operations for files systems. 3, 6 MC edit delete
141 1Z0-063 Which two are true about RMAN image copies? (Choose two.) The can only be written to disk. They are the only backup option available for database in NOARCHIVELOG mode. They can be encrypted using Transparent Data Encryption (TDE). They can be used as a level 0 incremental backup. 1, 4 SC edit delete
140 1Z0-063 You take regular backups of one of your production databases by using RMAN with a recovery catalog. You have added two new tablespaces to this database which must be included in future backups. Which process occurs which allows the new backups to contain the new datafiles? The target database control file is synchronized from the recovery catalog with a full resync at the next backup. The target database control file is synchronized from the recovery catalog with a partial resync at the next backup. The recovery catalog is synchronized from the target database control file with a full resync at the next backup. The recovery catalog is synchronized from the target database control file with a partial resync at the next backup. 1 SC edit delete
139 1Z0-063 Identify three reasons for using a recovery catalog with Recovery Manager (RMAN). (Choose three.) to report on the database schema at an earlier point in time to store backups that would cause the controlfile to become too large to allow database duplication without a connection to the target instance to allow database duplication without a connection to the auxiliary instance to store backup metadata that would cause the controlfile to become too large 1, 2, 3 MC edit delete
138 1Z0-063 One of your database runs in ARCHIVELOG mode. 138-queadv.png An online redo log will not be overwritten only if an archived log cannot be created in at least two of the non-mandatory destinations and LOG_ARCHIVE_DEST_4. An online redo log will not be overwritten only if an archived log cannot be created in at least two of the non-mandatory destinations. An online redo log will not be overwritten only if an archived log cannot be created in at least one of the non-mandatory destinations and LOG_ARCHIVE_DEST_4. An online redo log will not be overwritten only if an archived log cannot be created in LOG_ARCHIVE_DEST_4. 4 SC edit delete
137 1Z0-063 You want to create a guaranteed restore point for your databases by executing the command: 137-queadv.png A database backup must be taken. Fast Recovery Area must be enabled. Undo retention guarantee must be enabled The recyclebin must be enabled for the database Flashback Database must be enabled. The database must be running in ARCHIVELOG mode. 2, 6 MC edit delete
136 1Z0-063 You issued these commands for one of your databases: 136-queadv.png The cumulative incremental level 1 database backup ignores the block change tracking file. Future cumulative incremental level 1 database backups will reference the block change tracking file. Future incremental level 0 database backups will reference the block change tracking file. The cumulative incremental level 1 database backup fails. The block change tracking file will be updated automatically after creation to refer to modified blocks contained in the incremental level 0 database backup. 2, 5 MC edit delete
135 1Z0-063 One of your container databases (CDBs) has five pluggable databases (PDBs). 135-queadv.png The C##DBA_ADMIN user is able to create views in any PDB as a result of being granted the C##ROLE1 role. The C##DBA_ADMIN user is a local user in CDB$ROOT and PDB$SEED. The c##role1 role will always have the same privileges in all current and future PDBs. The C##DBA_ADMIN user is a local user in CDB$ROOT. SYSTEM is able to create views in any PDB as a result of being a DBA user. SYSTEM is able to create views in any PDB as a result of being granted the C##ROLE1 role. 1, 3, 6 MC edit delete
134 1Z0-063 One of your multitenant container databases (CDB) contains two pluggable databases (PDBs) called PDB1 and PDB2. 134-queadv.png The data dictionary in PDB2 is updated. The STATISTICS_LEVEL parameter is set to ALL in memory only for PDB2. The SPFILE is updated. The data dictionary in CDB$ROOT is updated. The STATISTICS_LEVEL parameter is set to ALL in memory for both PDBs. 2 SC edit delete
133 1Z0-063 One of your database suffered an instance failure. At the next startup, from which point in the redo logs does instance recovery begin? from a point corresponding to the most recent successful transaction commit from a point corresponding to the most recent log instance checkpoint from a point corresponding to the most recent incremental checkpoint from a point corresponding to the most recent checkpoint of any kind from a point corresponding to the most recent log switch checkpoint 1 SC edit delete
132 1Z0-063 Which three RMAN persistent settings can be set explicitly? (Choose three.) archivelog deletion policy SPFILE backup duplexing image copy duplexing archivelog backup duplexing redo log backup duplexing controlfile autobackup formats 1, 3, 6 MC edit delete
131 1Z0-063 Which two result in an inconsistent backup? (Choose two.) an RMAN backup taken for an open database in ARCHIVELOG mode a differential incremental backup a backup taken immediately after a SHUTDOWN ABORT command a user-managed backup taken for a closed database in NOARCHIVELOG mode an RMAN full backup taken for a database in NOARCHIVELOG mode 3, 5 MC edit delete
130 1Z0-063 What is the benefit of running the catctl.pl script during an upgrade of a pre-12c database to an Oracle 12c database? It generates a log file containing the fixes that can be made to the source database. It recompiles all invalid PLSQL and Java code. It provides parallel upgrade options to finish the upgrade process with a reduced down time. It provides a summary of the upgrade results. It generates fixup scripts to be run on the source database before upgrade. 3 SC edit delete
129 1Z0-063 You want to create a database with a block size other than the default 8 KB by using the Database Configuration Assistant (DBCA). Which option should you use? A custom database template A Data Warehouse database template Automatic Storage Management (ASM) for storage of data files A file system for storage of data files 1 SC edit delete
128 1Z0-063 Which activity is audited by default and recorded in the operating system audit trail irrespective of whether or not database auditing is enabled? configuration of unified auditing mode execution of SQL statements by users connected with the SYSDBA privilege usage of the AUDIT statement creation of a fine grained audit policy 3 SC edit delete
127 1Z0-063 Which three types of backups can be performed for a database running in NOARCHIVELOG mode? (Choose three.) consistent whole database backup backup of noncritical tablespaces without shutting down the instance backup of the database without shutting down the instance backup of only those blocks that have changed since the last backup while database is mounted backup of only the used blocks in a critical tablespace (SYSTEM or SYSAUX) while the database is open 1, 3, 4 MC edit delete
126 1Z0-063 Which two are prerequisites for performing Flashback Transaction? (Choose two.) A supplemental log must be enabled for the primary key. Undo retention guarantee must be configured for the database. Fast Recovery Area must be enabled for the database The EXECUTE privilege must be granted to a user on the DBMS_FLASHBACK package. Row movement must be enabled. 1, 4 MC edit delete
125 1Z0-063 You use RMAN to take regular backups for your database. 125-queadv.png All backups and archived redo log files that are not required for the recovery are deleted and the repository is updated. All metadata, for backups and archived redo log files that are recorded in the repository but do not exist on disk or media, is deleted. All backups that have exceeded the age set by the RMAN retention policy are deleted. All metadata pertaining to backups and archived redo log files that have exceeded the age set by the RMAN retention policy are deleted from the repository. 2 SC edit delete
124 1Z0-063 You are performing regular backups of your production database by using a recovery catalog. You add two new tablespaces to your production database after performing a backup. They must be included in future backups. Which action should you perform? Synchronize the recovery catalog with the target database control file. Create a new database incarnation record. Add the tablespaces in the recovery catalog by using the CATALOG command. Synchronize all the physical data files with the logical records in the recovery catalog by using the CROSSCHECK command. 1 SC edit delete
123 1Z0-063 Which three factors influences the optimizer's choice of an execution plan? (Choose three.) Cardinality estimates The OPTIMIZER_MODE initialization parameter Fixed baselines Type of connection used to connect to database instance Object statistics in the data dictionary 1, 2, 5 MC edit delete
122 1Z0-063 You issue the RMAN command: 122-queadv.png The resulting backupset has backup pieces that cannot exceed 300 MB. RMAN uses multiplexing to perform the backup. RMAN always performs this type of backup in parallel. The backup succeeds only if the USERS tablespace is locally managed. The backup set size is limited to 300 MB. 1 SC edit delete
121 1Z0-063 Your database is running in ARCHIVELOG mode. Complete database backups are performed daily at midnight. A user accidentally truncates an important table at 10 AM after the last backup. After that, a few important transactions are performed on the database. Which two best methods for recovering the truncated table data? (Choose two.) Table Point-in-Time Recovery Database Point-in-Time Recovery Tablespace Point-in-Time Recovery Flashback Database Flashback Transaction Backout 2, 4 MC edit delete
120 1Z0-063 Which three conditions must be met before you Virtual Private Catalog (VPC) can be created and used by an Administrator? (Choose three.) A base recovery catalog must exist. The owner of the VPC cannot own recovery catalog. At least one target database should be registered in the recovery catalog. The REGISTER DATABASE privilege should be granted to the virtual catalog owner. The DBA role must be granted to the virtual catalog owner. 1, 2, 5 MC edit delete
119 1Z0-063 You are administering a multitenant container database (CDB) CDB1 with two pluggable databases (PDBs), PDB1 and PDB2. 119-queadv.png It is created in all the PDBs with the CREATE SESSION privilege. It is created in all the PDBs but has the CREATE SESSION privilege only in CDB$ROOT. It is created and has the CREATE SESSION privilege only in a PDB that is open. It is created only in CDB$ROOT and has the CREATE SESSION privilege. 2 SC edit delete
118 1Z0-063 Which three statements are true about automated maintenance tasks? (Choose three.) Predefined maintenance tasks consist of automatic optimizer statistics collection, running Automatic Segment Advisor, and running Automatic SQL Tuning Advisor. A repository is maintained in the SYSTEM tablespace to store the history of execution of all tasks. They run at predefined time intervals that are intended to occur during a period of low system loads. An Oracle Scheduler job is created for each maintenance tasks that is scheduled to run in a maintenance window. A maintenance window is automatically extended until all the maintenance tasks defined are completed. 1, 3, 4 MC edit delete
117 1Z0-063 Which two statements are true about RMAN duplexed backups? (Choose two.) It is only supported for backups to tape via the media management interface. It is not supported for image copies. For performing duplexed backups, the parallelism for the device must be set equal to the number of copies. Duplex backups can be performed on either disk or media, but cannot be performed on media and disk simultaneously. Duplex backups can contain only data files and control files. 2, 4 MC edit delete
116 1Z0-063 Examine the statements that use flashback technologies: 116-queadv.png 1, 2, 5 1, 3, 6 2, 3, 5, 6 3, 4, 5 1 SC edit delete
115 1Z0-063 Your database instance is abnormally terminated because of a power outage. At the next startup, from which point in the redo log does the recovery start? from the last complete checkpoint position from the beginning of the current redo log file until the instance failure from the last committed transaction from the beginning of the current redo log file to the checkpoint position from the most recent incremental checkpoint 5 SC edit delete
114 1Z0-063 Which two statements are true about Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)? (Choose two.) If no PDB plan is enabled for a pluggable database, all sessions for that PDB are treated to an equal share of resources. To enable a resource plan for a PDB, a CDB resource plan must be created and enabled. If a PDB plan is enabled for a pluggable database, Resource Manager uses the resource allocation at the PDB level and ignores the limits set at the CDB level. If no PDB plan is enabled for a pluggable database, the PDB uses the CDB plan. If a PDB plan is enabled for a pluggable database, resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan. 1, 5 MC edit delete
113 1Z0-063 Which statement is true about the ALTER SESSION SET CONTAINER command to switch between containers? It can be executed only from CDB$ROOT. It rolls back any pending transactions in the container from which it is executed. It will not fire login triggers for the specified container. It cannot be used to connect to PDB$SEED. It cannot be used to connect to CDB$ROOT from a pluggable database (PDB). 4 SC edit delete
112 1Z0-063 Examine the probable steps involved in the basic backup process of RMAN and Oracle Secure Backup (OSB): 112-queadv.png 1, 3, 6, 7, 4 2, 1, 6, 4, 7 1, 3, 5, 7, 4 1, 3, 6, 4, 7 1 SC edit delete
111 1Z0-063 In CDB$ROOT of your multitenant container database (CDB), you create a common user, C##A_ADMIN, and then execute the command: 111-queadv.png The command executes successfully, enabling the C##A_ADMIN user to create a tablespace only in the root database. The command executes successfully, enabling the C##A_ADMIN user to create tablespaces in the root database, as well as in the pluggable databases (PDBs). The command fails because the CONTAINER clause is not used. The command fails because system privileges cannot be granted to a common user. 1 SC edit delete
110 1Z0-063 You need to perform a block media recovery on the tools01.dbf data file in your database by using Recovery Manager (RMAN). Which two are prerequisites for performing this operation? (Choose two.) You must configure a block change tracking file. You must use an incremental level-1 backup to restore blocks. You must ensure that the database is mounted or open. You must have full or level-0 backups to restore blocks You must take the tools01.dbf data file offline. 3, 4 MC edit delete
109 1Z0-063 You execute the command to recover your database: 109-queadv.png It restores all data files from the specified time, and then applies the redo logs It restores all data files, redo log files, and control files, and then applies the redo logs up to the specified time. It restores all data files and control files from the most recent backup taken before the “until time”, and then recovers up to the “until time” using any restored archive logs that are needed to complete the task. It restores the control file and all data files from the most recent backups, and then applies the redo logs up to the “until time” 3 SC edit delete
108 1Z0-063 You want to create a duplicate database DUP_DB from your production database PROD on the same host. 108-queadv.png The target database must be in MOUNT state. RMAN must be connected to the target database instance and the auxiliary instance. A most recent backup set of the PROD database must exist. Flashback must be enabled for the PROD database. 2 SC edit delete
107 1Z0-063 You regularly take backups of your database using RMAN with a recovery catalog. Your database is currently open and the temp01.dbf temp file belonging to the TEMP tablespace is corrupted. Identify two methods to recover the temp file with the least disruption to database availability. (Choose two.) Drop the TEMP tablespace, and then re-create it with new temp files. Restart the database instance to create the temp file automatically. Take the TEMP tablespace offline, drop the missing temp file, and then create a new temp file. Add a new temp file to the TEMP tablespace with a new name, and then drop the temp file that is corrupted 3, 4 MC edit delete
106 1Z0-063 You want to migrate your Oracle 11g database as a pluggable database (PDB) in a multitenant container database (CDB). 106-queadv.png 1, 5, 4, 7, and 6 3, 2, 5, 1, 4, and 7 2, 5, 1, 4, 7, and 6 2, 1, 3, 5, 7, and 6 3 SC edit delete
105 1Z0-063 Which three statements are true about the database instance startup after an instance failure? (Choose three.) The RECO process recovers the uncommitted transactions at the next instance startup. Online redo log files and archived redo log files are required to complete the rollback stage of instance recovery. Uncommitted changes are rolled back to ensure transactional consistency. The SMON process coordinates the database recovery. Media recovery is required to complete the database recovery Changes committed before the failure, which were not written to the data files, are re-applied 1, 3, 4 MC edit delete
104 1Z0-063 A database instance uses an SPFILE. Examine the parameter: 104-queadv.png 3, 4 2, 1, 4, 6 3, 1, 4, 6 1, 5, 2, 4, 6 2, 6 2 SC edit delete
103 1Z0-063 Which three methods can be used to create a pluggable database (PDB) in an existing multitenant container database (CDB)? (Choose three.) Use PDB$SEED for creating a PDB. Use the DBMS_PDB package to plug a non-CDB into an existing CDB. Clone an existing PDB. Use Enterprise Manager Database Express to create a PDB in an existing CDB. Use the DBMS_PDB package to plug a pre-Oracle 12c database into an existing CDB. 2, 3, 4 MC edit delete
102 1Z0-063 You are administering a multitenant container database (CDB) that contains multiple pluggable databases (PDBs). RMAN is connected to CDB$ROOT. Examine the command: RMAN> LIST FAILURE; Which statement is true about this command? It lists failures only for the CDB root database. It lists failures for a PDB only when RMAN is connected to a recovery catalog. It lists failures for the CDB and all the PDBs in this CDB. It lists failures only if RMAN is connected to a PDB. 1 SC edit delete
101 1Z0-063 Which three requirements should be successfully met by an Oracle Secure Backup (OSB) user so that OSB performs RMAN backup or restore requests? (Choose three.) RMAN preauthorization on the host OSB encryption for data in transport and on tape matching the OS user identity of the Oracle instance associated with the database username assigned to a class with rights to back up or restore Oracle database scheduling of the RMAN backup to occur automatically at user-defined intervals assigned to a class with rights to browse all directories and catalogs 1, 4, 6 MC edit delete
100 1Z0-063 You create a new database by using the CREATE DATABASE command in SQL *Plus, with the ENABLE PLUGGABLE DATABASE clause specified. Which statement is true about the database that is created? It is created as a container database (CDB) with CDB$ROOT, PDB$SEED, and a pluggable database (PDB). It is created as a non-CDB that becomes a CDB after the first PDB is plugged in. It is created as a PDB that must be plugged into an existing CDB. It is created as a CDB with the CDB$ROOT and PDB$SEED databases. 4 SC edit delete
99 1Z0-063 Examine the commands executed in CDB$ROOT of your multitenant container database (CDB) that has multiple pluggable databases (PDB): 99-queadv.png The command fails and gives an error because object privileges cannot be granted to a common user. The command fails because container is not set to current. The command succeeds and the common user c##admin can create a session and query the DBA_users view in cdb$root and all the PDBs. The command succeeds and the common user c##admin can create a session in cdb$root and all the PDBs, but can only query the dba_users view in cdb$root. The command succeeds and the common user c##admin can create a session and query the DBA_users view only in cdb$root. 3 SC edit delete
98 1Z0-063 You create a default Flashback Data Archive FLA1 and enable it for the EMPLOYEES table in the HR schema. After a few days, you want to alter the EMPLOYEES table by executing the command: SQL> ALTER TABLE EMPLOYEES ADD PHONE NUMBER(12); Which statement is true about the execution of the command? It gives an error because DDL statements cannot be executed on a table that is enabled for Flashback Data Archive. It executes successfully and all metadata related to the EMPLOYEES table before altering the table definition is purged from Flashback Data Archive. It executes successfully and continues to store metadata related to the EMPLOYEES table. It executes successfully but Flashback Data Archive is disabled for the EMPLOYEES table. 3 SC edit delete
96 1Z0-063 The CATDB12C database contains an Oracle Database 12c catalog schema owned by the RC12C user. The CATDB11 database contains an Oracle Database l1g catalog schema owned by the RC11 user. A database with DBID=1423241 is registered in the CATDB11 catalog. Both the recovery catalog databases are open. In the CATDB12c database, you execute the commands: 96-queadv.png It fails because the target database and recovery catalog database are of different versions. It succeeds and all global scripts in the RC11 catalog that have the same name as existing global scripts in the RC12C catalog are automatically renamed. It succeeds but the database is not automatically registered in the RC12c catalog. It fails because RMAN is not connected to the target database with DBID=1423241. 1 SC edit delete
95 1Z0-063 Which two statements are true about making RMAN image copies of a database? (Choose two.) They can only be written to disk. They can be made only when the database is running in NOARCHIVELOG mode. They can be made only when the database is in MOUNT state. They consist of all used and unused blocks in the data files They can be made only when the database is running in ARCHIVELOG mode. 1, 4 MC edit delete
94 1Z0-063 Identify three reasons for using a recovery catalog with Recovery Manager (RMAN). (Choose three.) to store backup information of multiple databases in one place to restrict the amount of space that is used by backups to maintain a backup for an indefinite period of time by using the KEEP FOREVER clause to store RMAN scripts that are available to any RMAN client that can connect to target databases registered in the recovery catalog to automatically delete obsolete backups after a specified period of time 1, 3, 4 MC edit delete
93 1Z0-063 Which three statements are true regarding the use of the Database Migration Assistant for Unicode (DMU)? (Choose three.) A DBA can check specific tables with the DMU The database to be migrated must be opened read-only The release of the database to be converted can be any release since 9.2.0.8. The DMU can report columns that are too long in the converted characterset The DMU can report columns that are not represented in the converted characterset 1, 4, 5 MC edit delete
92 1Z0-063 Examine the command to duplicate a database: 92-queadv.png The SPFILE is copied along with the data files of the pluggable databases (PDBs). A backup of pdb1 and pdb5 must exist before executing the command. The DUPLICATE command first creates a backup, and then duplicates the PDBs by using the backup. The root and the seed database in the container database (CDB) are also duplicated. An auxiliary instance must be started with the initialization parameter ENABLE_PLUGGABLE_DATABASE set to TRUE. 2, 5 MC edit delete
91 1Z0-063 As part of a manual upgrade process, after installing the software for Oracle Database 12c and preparing the new Oracle home, you shut down the existing single instance database. Which step should you perform next to start the upgrade of the database? Start up the database instance by using the new location of the server parameter file and run the catuppst.sqi script to generate informational messages and log files during the upgrade. Start up the database instance by using the new location of the server parameter file and run the cact1.pl script from the new Oracle home to use parallel upgrade options that reduce down time. Start up the database instance by using the STARTUP UPGRADE command and gather fixed object statistics to minimize the time needed for recompilation. Start up the database instance by using the STARTUP UPGRADE command, which opens the existing database, and then performs additional upgrade operations. 2 SC edit delete
90 1Z0-063 You issue the RMAN commands: 90-queadv.png switching the online redo log backing up all data files as image copies and archive logs, and deleting those archive logs backing up only the used blocks in the data files backing up all used and unused blocks in the data files backing up all archived logs and marking them as obsolete 1, 2, 4 MC edit delete
89 1Z0-063 Which statement is true about the loss or damage of a temp file that belongs to the temporary tablespace of a pluggable database (PDB)? The PDB is closed and the temp file is re-created automatically when the PDB is opened. The PDB is closed and requires media recovery at the PDB level. The PDB does not close and the temp file is re-created automatically whenever the container database (CDB) is opened. The PDB does not close and starts by using the default temporary tablespace defined for the CD. 3 SC edit delete
88 1Z0-063 Examine the RMAN commands executed in your database: RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk; RMAN> CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO BACKUPSET; RKAN> CONFIGURE CONTROLFILE AUTOBACKUP ON; You issue the command: RMAN> BACKUP DATABASE; Which two statements are true about the command? (Choose two.) 88-queadv.png It performs a log switch. It creates compressed backup sets by using binary compression by default. It backs up only the used blocks in data files. It backs up data files, the control file, and the server parameter file. It creates a backup of only the control file whenever the database undergoes a structural change. 3, 4 MC edit delete
87 1Z0-063 In your database, there are tablespaces that were read-only when the last backup was taken. These tablespaces have not been made read/write since then. You want to perform an incomplete recovery on the database by using a backup control file. What precaution must you take for the read-only tablespaces before performing an incomplete recovery? All the read-only tablespaces should be taken offline. All the read-only tablespaces should be restored separately. All the read-only tablespaces should be renamed to have the MISSINGnnnn format All the read-only tablespaces should be made online with logging disabled 1 SC edit delete
86 1Z0-063 Examine the output: 86-queadv.png Flashback data archives (FDA) Archived redo log files Control file autobackups Server parameter file (SPFILE) Recovery Manager (RMAN) backup pieces 2,3,5 MC edit delete
85 1Z0-063 Which three requirements must be met before a tablespace can be transported across different platforms? (Choose three.) Both the source and target databases must use the same character set. The platforms of both the source and target databases must have the same endian format. The compatible parameter value must be the same in the source and target databases. The minimum compatibility level for both the source and target databases must be 10.0.0. The tablespace to be transported must be in read-only mode. 1, 4, 5 MC edit delete
84 1Z0-063 Examine the RMAN command: 84-queadv.png It creates compressed backup sets. It uses asynchronous I/O for the backup. It uses parallelization for the backup set. It uses multisection backup. 3 SC edit delete
83 1Z0-063 Which three statements are true about compression of backup sets? (Choose three.) Compressed backups can only be written to media. Binary compression creates performance overhead during a backup operation. Unused blocks below the high-water mark are not backed up. Compressed backups cannot have section size defined during a backup operation It works only for locally managed tablespaces 2, 3, 5 MC edit delete
82 1Z0-063 Which two statements are true regarding SecureFile lobs? (Choose two.) The amount of undo retained is user controlled. They can be used only for nonpartitioned tables. Fragmentation is minimized by using variable-sized chunks. They support random reads and writes of encrypted LOB data. 3, 4 MC edit delete
81 1Z0-063 Which three conditions must be met before you create a Virtual Private Catalog (VPC)? (Choose three.) A base recovery catalog should exist. The owner of VPC cannot own recovery catalog. At least one target database should be registered in the recovery catalog. The register database privilege should be granted to the virtual catalog owner. The recovery_catalog_owner role should be granted to the virtual catalog owner. 1, 4, 5 MC edit delete
80 1Z0-063 You are administering a multitenant container database (CDB) that contains multiple pluggable databases (PDBs). 80-queadv.png It is created only in cdb$root and cannot be granted to the c##admin user with the container=all clause. It is granted to the c##admin user only in the CDB. It is granted to the c##admin user in all PDBs and can be granted only to a local user in a PDB. It is granted to the c##admin user in all PDBs and can be granted object and system privileges for a PDB. 4 SC edit delete
79 1Z0-063 Which two statements are true about Flashback Version Query? (Choose two.) The result of a query can be used as part of a DML statement. It can be used to create views. It can be used only if Flashback Data Archive is enabled for a table. It retrieves all versions of rows that exist in a time interval, including the start time and end time. It can be used to retrieve the SQL that is required to undo a row change and the user responsible for the change 4, 5 MC edit delete
78 1Z0-063 You create two Resource Manager plans, one for night time workloads, the other for day time. How would you make the plans switch automatically? Use job classes. Use scheduler windows. Use the mapping rule for the consumer groups. Set the switch_time plan directive for both plans. Use scheduler schedules. 2 SC edit delete
77 1Z0-063 You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference. Which method or feature should you use? Compare Period ADDM report AWR Compare Period report Active Session History (ASH) report Taking a new snapshot and comparing it with a preserved snapshot 2 SC edit delete
76 1Z0-063 You restore and recover your database to a new host by using an existing RMAN open database backup. Which step must you perform next? Execute catproc.sql to recompile invalid PL/SQL modules. Open the database with the RESETLOGS option. Set a new database identifier (DBID) for the newly restored database. Use the RMAN SET NEWNAME and SWITCH commands to switch to new files. 2 SC edit delete
75 1Z0-063 Your database supports an OLTP workload. 75-queadv.png Automatic checkpoint tuning is disabled. The frequency of log switches is increased. The overhead on database performance is increased because of frequent writes to disk. The MTTR advisor is disabled. 3 SC edit delete
74 1Z0-063 Consider the following scenario for your database: 74-queadv.png The RMAN backup fails because the tools tablespace is read-only. RMAN skips the backup of the tools tablespace because backup optimization is enabled. RMAN creates a backup of the tools tablespace because backup optimization is applicable only for the backups written to media. RMAN creates a backup of the tools tablespace because no backup of the tablespace exists within the seven-day recovery window 4 SC edit delete
73 1Z0-063 You want to move your existing recovery catalog to another database. 73-queadv.png 1, 6, 4 2, 3, 7, 5 1, 2, 6, 4 1, 2, 3, 6, 5 3 SC edit delete
72 1Z0-063 Your database supports an online transaction processing (OLTP) workload in which one of the applications creates a temporary table for a session and performs transactions on it. This consumes a lot of undo tablespace and is affecting undo retention. Which two actions would you take to solve this problem? (Choose two.) Enable temporary undo for the database. Enable undo retention guarantee. Increase the size of the redo log buffer. Enable Automatic Memory Management (AMM). Increase the size of the temporary tablespace. 1, 5 MC edit delete
71 1Z0-063 A user issues a query on the sales table and receives the following error: 71-queadv.png Drop the tenp01.dbf file, and then re-create the temp file. Add a new temp file to the temporary tablespace and drop the temp01.dbf file Shut down the database instance, start up the database instance in mount state, create a new temporary tablespace, and then open the database. Take the temporary tablespace offline, recover the missing temp file, and then bring the temporary tablespace online. Create a new temporary tablespace and assign it as the default to the user. 2, 5 MC edit delete
70 1Z0-063 RMAN is connected to the target database prod1 and an auxiliary instance in nomount state. 70-queadv.png All archive redo log files are automatically copied to the duplicate database. The duplicate database has the same directory structure as the source database The duplicate database is created by using the backups created during the execution of the DUPLICATE command. The password file and SPFILE for the duplicate database DUP1 are created in their respective default locations. The duplicate database is created without using RMAN backups and PROD1 is allowed to remain open during duplication. 2,5 MC edit delete
69 1Z0-063 user_data is a non-encrypted tablespace containing tables with data. You must encrypt all data in this tablespace. Which three methods can do this? (Choose three.) Use Data Pump Use ALTERTABLE. . .MOVE Use CREATE TABLE AS SELECT Use alter tablespace to encrypt the tablespace after enabling row movement on all its disk space Use altertablespace to encrypt the tablespace. 1, 2, 3 MC edit delete
68 1Z0-063 Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.) The ADR base is shared across multiple instances. The ADR base keeps all diagnostic information in binary format. The ADR can be used to store statspack snapshots to diagnose database performance issues. The ADR can be used for problem diagnosis even when the database instance is down. The ADR is used to store Automatic Workload Repository (AWR) snapshots. 1, 4 MC edit delete
67 1Z0-063 For which two requirements would you use the Database Resource Manager? (Choose two.) limiting the CPU used per database call specifying the maximum number of concurrent sessions allowed for a user specifying the amount of private space a session can allocate in the shared pool of the SGA limiting the degree of parallelism of operations performed by a user or group of users specifying an idle time limit that applies to sessions that are idle and blocking other sessions 4, 5 MC edit delete
66 1Z0-063 Which three statements are true about the keystore storage framework for transparent data encryption? (Choose three.) It facilitates and helps to enforce keystore backup requirements. It handles encrypted data without modifying applications. It enables a keystore to be stored only in a file on a file system. It enables separation of duties between the database administrator and the security administrator. It transparently decrypts data for the database users and applications that access this data. It helps to track encryption keys and implement requirements such as keystore password rotation and master encryption key reset or re-key operations. 1, 4, 6 MC edit delete
65 1Z0-063 You are administering a database that supports data warehousing workload and is running in noarchivelog mode. 65-queadv.png 4, 8, 11, 5 1, 3, 8, 11, 9 1, 2, 6, 3, 7, 10, 9 1, 3, 7, 10, 9 1, 2, 6, 3, 8, 11, 9 3 SC edit delete
64 1Z0-063 Examine the command to back up the ASM metadata: ASMCMD> md_backup /backup/ASM_backup. In which three situations can you use the backup? (Choose three.) when one or more disks in an ASM disk group are lost when the data file on an ASM disk group gets corrupted when one of the disks in a disk group is accidentally unplugged when one or more file directory paths are accidentally deleted from an ASM disk group when all the ASM disk groups for the ASM instance are lost 1, 4, 5 MC edit delete
63 1Z0-063 You are administering a multitenant container database (COB) that contains two pluggable databases (PDBs), pdb1 and pdb2. 63-queadv.png The statistics_level parameter is set to all when any of the PDBs is reopened. The statistics_level parameter is set to all only for PDB2 when it is reopened. The statistics_level parameter is set to all when the root database is restarted. The statement is ignored because there is no SPFILE for a PDB 2 SC edit delete
62 1Z0-063 LDAP_DIRECTORY_SYSAUTH is set to YES. 62-queadv.png authentication by password file authentication by using certificates over SSL authentication by using the Oracle Internet Directory authentication by using the local OS of the database server 1 SC edit delete
61 1Z0-063 Which two are prerequisites for creating a backup-based duplicate database? (Choose two.) connecting to the target database and a recovery catalog to execute the duplicate command creating a password file for an auxiliary instance connecting to an auxiliary instance matching the database identifier (DBID) of the source database and the duplicate database creating an SPFILE for the target database 1, 2 MC edit delete
60 1Z0-063 Which three statements correctly describe the relationship amongst jobs, programs, and schedules within the Oracle Job Scheduler? (Choose three.) A job is specified as part of a program definition. A program can be used in the definition of multiple jobs. A program and job can be specified as part of a schedule definition. A program and schedule can be specified as part of a job definition. A program and window can be specified as part of a job definition. 2, 4, 5 MC edit delete
59 1Z0-063 Your database is running in ARCHIVELOG mode. 59-queadv.png An online redo log file is not allowed to be overwritten if the archived log file cannot be created in any of the LOG_ARCHIVE_DEST_.n destinations. Optional destinations cannot use the fast recovery area. An online redo log file is not allowed to be overwritten if the archived log file cannot be created in the location specified for LOG_ARCHIVE_DEST_4. These settings work only if LOG__ARCHIVE_MIN_SUCCEED_DEST is set to a value of 4. 3 SC edit delete
58 1Z0-063 Examine the backup requirement for your company: 58-queadv.png level 0 backup on Sunday, cumulative incremental backup on Wednesday and Friday, and differential incremental level 1 backup on all the other days level 0 backup on Sunday, differential incremental backup on Wednesday and Friday, and cumulative incremental level 1 backup on all the other days full database backup on Sunday, level 0 backup on Wednesday and Friday, and cumulative incremental level 1 backup on all the other days full database backup on Sunday, level 0 backup on Wednesday and Friday, and differential incremental level 1 backup on all the other days 1 SC edit delete
57 1Z0-063 You want to migrate your Oracle 11g database as a pluggable database (PDB) in a multitenant container database (CDB). 57-queadv.png 2, 1, 3, 4, 5, 6 1, 3, 4, 5, 6, 7 1, 4, 3, 5, 6, 7 2, 1, 3, 4, 5, 6, 7 1, 5, 6, 4, 3, 2 3 SC edit delete
56 1Z0-063 While performing database backup to tape via the media manager interface, you notice that tape streaming is not happening because RMAN is not sending data blocks fast enough to the tape drive. Which two actions would you take for tape streaming to happen during the backup? (Choose two.) Configure backup optimization. Configure the channel to increase maxopenfiles. Configure a backup policy by using incremental backups. Configure the channel to increase capacity with the rate parameter. Configure the channel to adjust the tape buffer size by using the 3LKSIZE option. Configure large_pool, if not done already. Alternatively, you can increase the size of large_pool. 2,5 MC edit delete
55 1Z0-063 Your database is running in noarchivelog mode. One of the data files belonging to the system tablespace is corrupted. You notice that all online redo logs have been overwritten since the last backup. Which method would you use to recover the data file? Shut down the instance if not already shut down, restore all data files belonging to the system tablespace from the last backup, and restart the instance. Shut down the instance if not already shut down, restore the corrupted data file belonging to the system tablespace from the last backup, and restart the Instance. Shut down the instance if not already shut down, restore all data files for the entire database from the last backup, and restart the instance. Mount the database, restore all data files belonging to the system tablespace from the last backup, and open the database. 3 SC edit delete
54 1Z0-063 View the Exhibit showing steps to create a database resource manager plan. 54-queadv.png The pending area is automatically submitted when creating plan directives. The procedure must be executed before creating any plan directive. The sys_group group is not included in the resource plan. The other_groups group is not included in the resource plan. Pending areas can not be validated until submitted. 4 SC edit delete
53 1Z0-063 Your multitenant container database (CDB) cdb1 that is running in archivelog mode contains two pluggable databases (PDBs), pdb2_1 and pdb2_2. 53-queadv.png It fails because archive log files cannot be backed up using a connection to a PDB. It succeeds but only the data files belonging to the pdb2_1 pluggable database are backed up. It succeeds and all data files belonging to PD32_1 are backed up along with the archive log files. It fails because the pluggable clause is missing. 2 SC edit delete
52 1Z0-063 You have installed two 64G flash devices to support the Database Smart Flash Cache feature on your database server that is running on Oracle Linux. 52-queadv.png Set DB_FLASH_CACHE_SIZE=64G. Set D3_FLASH_CACHE_SIZE=64G, 64G. Set D3_FLASK_CACKE_SI2E=128G. db_flash_cache_SI2E is automatically configured by the instance at startup. 2 SC edit delete
51 1Z0-063 You created a tablespace with this statement: 51-queadv.png ALTER TABLESPACE adtbs RESI2E 20G; ALTER TABLESPACE adtbs ADD DATAFILE; ALTER TABLESPACE adtbs AUTOEXTEND ON; ALTER TABLESPACE adtbs ADD DATAFILE '/proddb/data/adtbsl.dbf' SIZE 1QG; ALTER TABLESPACE adtbs MODIFY DATAFILE '/proddb/data/adtbs.dbf AUTOEXTEND ON; 1,3 MC edit delete
50 1Z0-063 Automatic Shared Memory Management (ASMm) is enabled for your database instance, but parameters for the managed components are not defined. 50-queadv.png The minimum size for the standard buffer cache is 100 MB The maximum size for the standard buffer cache is 100 MB The minimum space guaranteed in the buffer cache for any server process is 100 MB The maximum space in the buffer cache that can be released for dynamic distribution is 100 MB The minimum size for all buffer caches is 100 MB 1 SC edit delete
49 1Z0-063 Examine the commands executed to monitor database operations: 49-queadv.png Database operations will be monitored only when they consume a significant amount of resource Database operations for all sessions will be monitored Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + TUNING Only DML and DDL statements will be monitored for the session. All subsequent statements in the session will be treated as one database operation and will be monitored 3,5 MC edit delete
48 1Z0-063 Examine the resources consumed by a database instance whose current Resource Manager plan is displayed. 48-queadv.png An attempt to start a new session by a user belonging to DSS_QUERIES fails with an error. An attempt to start a new session by a user belonging to OTHE_GROUPS fails with an error The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to resource management The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to I/O waits and latch or enqueue contention A user belonging to the DSS__QUERIES resource consumer group can create a new session but the session will be queued 3,5 MC edit delete
47 1Z0-063 Your multitenant container database (CDB) cdb1, 47-queadv.png All redo log files are opened. The root, the seed, and all the PDBs are opened in read-write mode. All the PDBs are opened in read-write mode. All the PDBs are in closed state. Only the root database is opened in read-write mode. 1, 5 MC edit delete
46 1Z0-063 You issue commands in SQL*Plus as the Oracle owner 46-queadv.png because the threaded architecture requires exiting from sql*plus and reconnecting with sql*Plus / as sysdba before issuing a startup command because the threaded architecture requires issuing a new connect / as sysdba from within sql*plus before issuing a startup command because the threaded architecture requires authentication using a password file before issuing a startup command because the threaded architecture requires connecting to the instance via a listener before issuing a startup command because the threaded architecture requires restarting the listener before issuing a startup command 3 SC edit delete
45 1Z0-063 Your multitenant container database (CDB) CDB1 that is running in ARCHIVELOG mode contains two pluggable databases (PDBs), PDB2_1 and PDB2_2, both of which are open. 45-queadv.png All data files belonging to PDB2_1 are backed up and all archive log files are deleted. All data files belonging to PDB2_1 are backed up along with the archive log files. Only the data files belonging to pdb2_1 are backed up. This command gives an error because archive log files can be backed up only when RMAN is connected to the root container database. 2 SC edit delete
44 1Z0-063 Examine the following steps of privilege analysis for checking and revoking excessive, unused privileges granted to users: 44-queadv.png 1, 3, 5, 6, 2, 4 1, 3, 6, 2, 5, 4 1, 3, 2, 5, 6, 4 1, 3, 5, 2, 6, 4 2 SC edit delete
43 1Z0-063 A telecom company wishes to generate monthly bills to include details of customer calls, listed in order of time of call. Which table organization allows for generating the bills with minimum degree of row sorting? a hash cluster an index cluster a partitioned table a sorted hash cluster a heap table with a rowid column 4 SC edit delete
42 1Z0-063 Which three statements are true about the startup and shutdown of multitenant container databases (CDBs) and pluggable databases (PDBs)? (Choose three.) A PDB opened in restricted mode allows only local users to connect. When a CDB is open in restricted mode, PDBs must also be opened in restricted mode. When a CDB is in mount state, PDBs are automatically placed in mount state. All PDBs must be shut down before shutting down a CDB instance. When a CDB instance is started, PDBs can be placed in open state by using database triggers or by executing the alter pluggable database command. 2, 3, 5 MC edit delete
41 1Z0-063 You use RMAN with a recovery catalog to back up your database. 41-queadv.png 1, 8, 3, 2, 4, 5, 7, 6 8, 1, 3, 2, 4, 5, 7, 6 1, 3, 2, 4, 8, 5, 6, 7 8, 3, 2, 4, 5, 7, 6 8, 1, 3, 2, 4, 5, 6 2 SC edit delete
40 1Z0-063 What can be automatically implemented after the SQL Tuning Advisor is run as part of the Automated Maintenance Task? statistics recommendations SQL profile recommendations SQL statement restructure recommendations creation of materialized views to improve query performance 2 SC edit delete
39 1Z0-063 You are administering a multitenant container database (CDB) CDB1 that is running in ARCHIVELOG mode and contains pluggable databases (PDBs), PDB_1 and PDB_2. 39-queadv.png The command performs the recovery and closes the failure. The command produces an error because RMAN is not connected to the target database pdb_1. The command produces an error because the ADVISE FAILURE command was not executed before the REPAIR FAILURE command. The command executes successfully, performs recovery, and opens PDB_1. 3 SC edit delete
38 1Z0-063 You specified the warning and critical thresholds for a locally managed tablespace to be 60% and 70%, respectively. From the tablespace space usage metrics, you find that the space usage has reached the specified warning threshold value, but no alerts have been generated. What could be the reason for this? The event parameter was not set. The sql_trace parameter is set to false. Enterprise Manager was not used. The statistics_level parameter is set to basic The timed_statistics parameter is set to false. 4 SC edit delete
37 1Z0-063 Examine the command used to perform an incremental level-0 backup: 37-queadv.png The block change tracking data is used only from the next incremental backup. The incremental level 1 backup fails because a block change tracking file Is created after the level 0 backup The incremental level 1 backup does not use change tracking data for accomplishing the backup. The block change tracking file scans all blocks and creates a bitmap for the blocks backed up in the level 0 backup. The block change tracking data is used for the next incremental level 1 backup only after the next level 0 backup. 3, 5 MC edit delete
36 1Z0-063 Evaluate these statements: 36-queadv.png Partitions of purchase_order_items are assigned unique names based on a sequence. The purchase_orders and purchase_order_items tables are created with four partition each. purchase_order_items table partitions exist in the same tablespaces as the purchase_orders table partitions. The purckase_order_:teks table inherits the partitioning key by duplicating the key columns from the parent table. Partition maintenance operations on the purchase_order_items table require disabling the foreign key constraint. 2, 3 MC edit delete
35 1Z0-063 Users report this error message when inserting rows into the orders table: 35-queadv.png drop and re-create the index coalesce the order.ind index coalesce the indexes tablespace perform an on line table rebuild using dbms_redefinition rebuild the index online moving it to another tablespace that has enough free space for the index 2, 5 MC edit delete
34 1Z0-063 You must unload data from the orders, order_items, and products database tables to four files using the External Tables. 34-queadv.png TYPE LOCATION PARALLEL DIRECTORY DEFAULT ORGANIZATION EXTERNAL 3 SC edit delete
33 1Z0-063 In your multitenant container database (CDB) that contains pluggable databases (PDBs), the hr user executes the following commands to create and grant privileges on a procedure: 33-queadv.png Create the create_test procedure with definer’s rights. Grant the execute privilege to users with grant option on the create_test procedure. Create the create_test procedure with invoker’s rights. Create the create_test procedure as part of a package and grant users the execute privilege on the package. 3 SC edit delete
32 1Z0-063 You install "Oracle Grid Infrastructure for a standalone server" on a host on which the orcl1 and orcl2 databases both have their instances running. Which two statements are true? (Choose two.) Both orcl1 and orcl2 are automatically added to the Oracle Restart configuration. All database listeners running from the database home are automatically added to the Oracle Restart configuration. The srvct1 add database command must be used to add orcl1 and orcl2 to the Oracle Restart configuration. The crsct1 start has command must be used to start software services for Oracle Automatic Storage Management (ASM) after the "Oracle Grid Infrastructure for a standalone server" installation is complete. All databases subsequently created by using the Database Configuration Assistant (DBCA) are automatically added to the Oracle Restart configuration. 3, 5 MC edit delete
31 1Z0-063 Your database supports a Decision Support System (DSS) workload that involves the execution of complex queries. Currently, the database is running with peak workload. You want to analyze some of the most resource-intensive statements cached in the library cache. What must you run to receive recommendations on the efficient use of indexes and materialized views to improve query performance? SQL Performance Analyzer SQL Access Advisor SQL Tuning Advisor Automatic Workload Repository (AWR) report Automatic Database Diagnostic Monitor (ADDM) 2 SC edit delete
30 1Z0-063 In which situation can you use Flashback Database? when undoing a shrink data file operation when retrieving a dropped tablespace when returning to a point in time before the restoration or re-creation of a control file when returning to a point in time before the most recent open resetlogs operation 2 SC edit delete
29 1Z0-063 Examine the steps/operations performed during the RMAN backup operation by using Oracle Secure Backup (OSB): 29-queadv.png 1, 4, 6, 5, 8, 3, 9 1, 6, 4, 5, 8, 3, 9 2, 4, 6, 5, 8, 3, 7 2, 4, 5, 8, 3, 7, 9 3 SC edit delete
28 1Z0-063 Which two statements are true about a multitenant architecture? (Choose two.) Each pluggable database (PDB) has its own initialization parameter file. A PDB can have a private undo tablespace. Log switches occur only at the container database level. Log switches occur only at the container database level. Each PDB has a private control file. 3, 4 MC edit delete
27 1Z0-063 Examine these Data Pump commands to export and import objects from and to the same database. 27-queadv.png expdp will fail because no path has been defined for the dumpfile. expdp will succeed but impdp will fail because the users do not exist. inpdp will create two users called hr1 and oe1 and import all objects to the new schemas impdp will create two users called hr1 and oe1 and import only the tables owned by hr and oe schemas to ht1 and oe1 schemas, respectively. 2 SC edit delete
26 1Z0-063 Automatic Undo Management is enabled for your database. You want a user to retrieve metadata and historical data for a given transaction or for transactions in a given time interval. Which three are prerequisites to fulfill this requirement? (Choose three.) Minimal supplemental logging must be enabled. The database must be running in archivelog mode. Flashback Data Archive must be created and the flashback archive administer system privilege must be granted to the user. The flashback any table privilege must be granted to the user. The select any transaction privilege must be granted to the user. The recycle bin parameter must be set to on. 1, 2, 5 MC edit delete
25 1Z0-063 A database is running in archivelog mode. You want to back up a 10 TB data file belonging to the users tablespace. The backup of the data file is too slow. What type of backup do you recommend to improve the performance of the backup? image copy backup by using RMAN multisection image copy backup by using RMAN multisection parallel backup by using RMAN cold backup after taking the tablespace offline cold backup after placing the tablespace in backup mode 3 SC edit delete
24 1Z0-063 In the SPFILE, UNDO TABLESPACE is Set to UNDOTBS. 24-queadv.png The tablespace will be renamed but the data file headers will not be updated. The statement will fail because you cannot rename an undo tablespace. The tablespace will be renamed and all the changes will be logged in the alert log The tablespace will be renamed and a message written to the alert log indicating that you should change the corresponding initialization parameter. You must set the undo_tablespace parameter to some other tablespace name before renaming undotbs. 3 SC edit delete
23 1Z0-063 In which three scenarios is media recovery required? (Choose three.) when a tablespace is accidentally dropped from a database when archived redo log files are lost when data files are lost when one of the online redo log members is corrupted when all control files are lost 1, 3, 5 MC edit delete
22 1Z0-063 Which two methods can be used to add an Oracle 11g database to a multitenant container database (CDB) as a pluggable database (PDB)? (Choose two.) Use the DBMS_PDB package to plug the Oracle 11g database into the existing CDB as a PDB. Use the CREATE DATABASE ... ENABLE PLUGGABLE DATABASE statement to create a PDB by copying data files from PDB$SEED and use data pump to load data from the Oracle 11g database into the newly created PDB. Pre-create a PDB in CDB and use data pump to load data from the complete database export of the Oracle 11g database into the newly created PDB. Pre-create a PDB in CDB and use the NETWORK_LINK and PARALLEL parameters with data pump import to import data from the Oracle 11g database to the newly created PDB. Upgrade the Oracle 11g database to a 12c non-CDB and use the DBMS_PDB.DESCRIBE procedure to plug the database as a new PDB into the CDB 4, 5 MC edit delete
21 1Z0-063 After implementing full Oracle Data Redaction, you change the default value for the number data type as follows: 21-queadv.png Re-enable redaction policies that use FULL data redaction. Re-create redaction policies that use FULL data redaction. Re-connect the sessions that access objects with redaction policies defined on them. Flush the shared pool Restart the database instance 5 SC edit delete
20 1Z0-063 Your database is running in archivelog mode and a nightly backup of the database, along with an autobackup of the control file, is taken by using RMAN. Because of a media failure, the SPFILE and the control files are lost. 20-queadv.png 1, 2, 5, 3, 6, 4 1, 2, 3, 5, 6, 4 2, 1, 5, 7, 3, 4 2, 1, 5, 6, 7, 4, 3 3 SC edit delete
19 1Z0-063 Which two statements are true about recovering logically corrupted tables or table partitions from an RMAN backup? (Choose two.) Tables or table partitions can be recovered by using an auxiliary instance only. Tables or table partitions with a foreign key cannot be recovered. Tables or table partitions can be recovered only when the database is in mount state. Tables or table partitions from the system and sysaux tablespaces cannot be recovered. Tables with not null constraints cannot be recovered 1, 4 MC edit delete
18 1Z0-063 Your database is running in archivelog mode. 18-queadv.png The database instance hangs and the redo log files are not overwritten. The archived redo log files are written to the fast recovery area until the mandatory destination is made available. The database instance is shutdown immediately. The destination set by the LOG_ARCHIVE_DEST_1 parameter is ignored and the archived redo log files are created in the next two available locations to guarantee archive log success. 4 SC edit delete
17 1Z0-063 The following parameters are set for your Oracle 12c database instance: 17-queadv.png 2, 4, 5 2, 1, 4, 3, 5 1, 2, 3, 4, 5 1, 2, 4, 5 2 SC edit delete
16 1Z0-063 Examine the RMAN command: 16-queadv.png password-mode encryption dual-mode encryption transparent encryption default encryption 1 SC edit delete
15 1Z0-063 Examine the steps to configure Oracle Secure Backup (OSB) for use with RMAN: 15-queadv.png 1, 4, 3, 2, 5 1, 3, 4, 5, 2 4, 3, 1, 2, 5 4, 3, 5, 1, 2 3 SC edit delete
14 1Z0-063 Examine the initialization parameter that is set in the PFILE: 14-queadv.png It creates a multitenant container database with a root and a seed pluggable database (PDB) that are opened in read-write and read-only modes, respectively. The files created for both the root and seed databases use Oracle Managed Files (OMF). It creates a multitenant container database with the root and seed databases opened and one PDB mounted. It sets the users tablespace as the default for both the root and seed databases. undotbs1 is used as the undo tablespace for both the root and seed databases. It creates a multitenant container database with the root database opened and the seed database mounted 1, 2, 5 MC edit delete
13 1Z0-063 A database is running in archivelog mode. 13-queadv.png 3, 2, 1, 4 2, 3, 4, 1 4, 1, 3, 2 3, 2, 4, 1 2 SC edit delete
12 1Z0-063 Which two resources might be prioritized between competing pluggable databases (PDBs) when creating a multitenant container database (CDB) plan using Oracle Database Resource Manager? (Choose two.) maximum undo per consumer group maximum idle time for a session in a PDB parallel server limit CPU maximum number of sessions for a PDB 3, 4 MC edit delete
11 1Z0-063 Which two statements are true when row-archival management is enabled? (Choose two.) Visibility of the ORA_ARCHIVE_STATE column is controlled by the row archival visibility session parameter. The ORA_ARCHIVE_STATE column is updated manually or by a program that can reference activity tracking columns, to indicate that a row is no longer considered active. The row archival visibility session parameter defaults to all rows. The ORA_ARCHIVE_STATE column is visible if it is referenced in the select list of a query The ORA_ARCHIVE_STATE column is updated automatically by the database based on activity tracking columns, to indicate that a row is no longer considered active. 2, 4 MC edit delete
10 1Z0-063 You want to consolidate backup information and centrally manage backup and recovery scripts for multiple databases running in your organization. Which two backup solutions can be used? (Choose two.) RMAN recovery catalog RMAN Media Management Library Enterprise Manager Cloud Control Enterprise Manager Database Express Oracle Secure Backup 1, 3 MC edit delete
9 1Z0-063 In your database, the tbs percent used parameter is set to 60 and the tbs percent free parameter is set to 20. Which two storage-tiering actions might be automated when using Information Lifecycle Management (ILM) to automate data movement? (Choose two.) The movement of all segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds tbs percent used Setting the target tablespace to read-only after the segments are moved The movement of some segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds T3S percent used Taking the target tablespace offline after the segments are moved The movement of some blocks to a target tablespace with a lower degree of compression, on a different storage tier, when the source tablespace exceeds tbs percent used 2, 3 MC edit delete
8 1Z0-063 A database is running in archivelog mode. The database contains locally managed tablespaces. Examine the RMAN command: RMAN> BACKUP AS COMPRESSED BACKUPSET SECTION SIZE 1024M DATABASE; Which statement is true about the execution of the command? The backup succeeds only if all the tablespaces are locally managed The backup succeeds only if the RMAN default device for backup is set to disk. The backup fails because you cannot specify section size for a compressed backup. The backup succeeds and only the used blocks are backed up with a maximum backup piece size of 1024 MB. 4 SC edit delete
7 1Z0-063 Your Oracle 12c multitenant container database (CDB) contains multiple pluggable databases (PDBs). 07-queadv.png C##ADMIN can create and select any table, and grant the c##ROLE1 role to users only in the root container B_ADMIN can create and select any table in both the root container and HR_PDB C##ADMIN can create and select any table in the root container and all the PDBs B_ADMIN can create and select any table only in HR_PDB The GRANT c##role1 TO b_admin command returns an error because CONTAINER should be set to ALL 3,4 MC edit delete
6 1Z0-063 The environmental variable oracle_Base is set to /u01/app/oracle and oracle_home is set to /u01/app/oracle/product/12.1.0/db 1. 06-queadv.png It is set to /u01/app/oracle/product:/12.1.0/db_1/log. It is set to /u01/app/oracle/admin/enl2r&p/adump It is set to /u01/app/oracle It is set to /u01/app/oracle/flash_recovery_area. 3 SC edit delete
5 1Z0-063 Examine the command: 05-queadv.png The current online redo log file is missing. A data file belonging to a noncritical tablespace is missing All the control files are missing. The control file backup is older than the database backup All the data files are missing. 3, 4 MC edit delete
4 1Z0-063 You notice performance degradation in your production Oracle 12c database. You want to know what caused this performance difference. Which method or feature should you use? Database Replay Automatic Database Diagnostic Monitor (ADDM) Compare Period report Active Session History (ASH) report SQL Performance Analyzer 2 SC edit delete
3 1Z0-063 For which three pieces of information can you use the RMAN list command? (Choose three.) stored scripts in the recovery catalog available archived redo log files backup sets and image copies that are obsolete backups of tablespaces backups that are marked obsolete according to the current retention policy 1, 2, 4 MC edit delete
2 1Z0-063 A complete database backup to media is taken for your database every day. Which three actions would you take to improve backup performance? (Choose three.) Set the backup_tape_io_slaves parameter to true. Set the dbwr_io_slaves parameter to a nonzero value if synchronous I/O is in use Configure large pool if not already done. Remove the rate parameter, if specified, in the allocate channel command. Always use RMAN compression for tape backups rather than the compression provided by media manager. Always use synchronous I/O for the database. 2, 3, 4 MC edit delete
1 1Z0-063 Which two statements are true about scheduling operations in a pluggable database (PDB)? (Choose two.) Scheduler jobs for a PDB can be defined only at the container database (CDB) level. A job defined in a PDB runs only if that PDB is open. Scheduler attribute setting is performed only at the CDB level Scheduler objects created by users can be exported or imported using Data Pump. Scheduler jobs for a PDB can be created only by common users. 2, 4 MC edit delete

Copyright © Designed & Developed by Sakthi Db Technology 2018